/*
    Project: OCMF (Operant Chamber Management Framework)
    Version: 1.0
    Author: Copyright (C) 2010, Samuel Delaney & Andrew Harvey
    Licence:
        This file is part of OCMF.

            OCMF is free software: you can redistribute it and/or modify
            it under the terms of the GNU General Public License as published by
            the Free Software Foundation, either version 3 of the License, or
            (at your option) any later version.

            OCMF is distributed in the hope that it will be useful,
            but WITHOUT ANY WARRANTY; without even the implied warranty of
            MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
            GNU General Public License for more details.

            You should have received a copy of the GNU General Public License
            along with OCMF.  If not, see <http://www.gnu.org/licenses/>.
*/

#include <QString>

#ifndef DBSQLSTATEMENTS_H
#define DBSQLSTATEMENTS_H

//class SqlStatments
//{
//public:
//
//    //SELECTS
//    static QString SELECT_SCHEDULED_EXPERIMENTS;
//
//    //INSERTS
//
//    //UPDATES
//    static QString UPDATE_SERVER_STATUS;
//
//
//};

//SELECTS

static const QString SELECT_SCHEDULED_EXPERIMENTS = "SELECT file FROM experiments INNER JOIN experimentqueue ON experiments.experimentId = experimentqueue.experimentId WHERE chamberId = :chamberId";

//INSERTS

//UPDATES
static const QString UPDATE_SERVER_STATUS = "UPDATE chambers SET lastStatus = :lastStatus, lastUpdated = :lastUpdated, runningExperiment = :runningExperiment WHERE chamberId = :chamberId";

#endif // DBSQLSTATEMENTS_H
